Demanda vs temperatura real Sonora

Dataset statistics

Number of variables	13
Number of observations	138791
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	13.8 MiB
Average record size in memory	104.0 B

Variable types

DateTime	1
Numeric	12

Alerts

`Demanda` is highly correlated with `Month` and 6 other fields	High correlation
`TMAX-CAB` is highly correlated with `Demanda` and 6 other fields	High correlation
`TMAX-HMO` is highly correlated with `Demanda` and 6 other fields	High correlation
`TMAX-OBR` is highly correlated with `Demanda` and 6 other fields	High correlation
`TMIN-CAB` is highly correlated with `Demanda` and 6 other fields	High correlation
`TMIN-HMO` is highly correlated with `Demanda` and 6 other fields	High correlation
`TMIN-OBR` is highly correlated with `Demanda` and 6 other fields	High correlation
`Month` is highly correlated with `Demanda` and 6 other fields	High correlation
`Date` has 19847 (14.3%) zeros	Zeros
`Hour` has 5782 (4.2%) zeros	Zeros
`PREC_HMO (mm)` has 120839 (87.1%) zeros	Zeros
`PREC_OBR (mm)` has 122255 (88.1%) zeros	Zeros

Reproduction

Analysis started	2022-11-07 03:45:01.774779
Analysis finished	2022-11-07 03:45:18.986628
Duration	17.21 seconds
Software version	pandas-profiling v3.3.0
Download configuration	config.json

FECHA
Date

Distinct	5783
Distinct (%)	4.2%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

Minimum	2007-01-01 00:00:00
Maximum	2022-10-31 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Demanda
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	45638
Distinct (%)	32.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2505.570239

Minimum	959
Maximum	5402.72
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	959
5-th percentile	1408
Q1	1867
median	2343.74
Q3	3054.1
95-th percentile	4079
Maximum	5402.72
Range	4443.72
Interquartile range (IQR)	1187.1

Descriptive statistics

Standard deviation	823.7167817
Coefficient of variation (CV)	0.3287542168
Kurtosis	-0.2876228818
Mean	2505.570239
Median Absolute Deviation (MAD)	559.74
Skewness	0.6406278244
Sum	347750599
Variance	678509.3364
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1600	82	0.1%
1786	80	0.1%
1515	78	0.1%
1497	76	0.1%
1574	72	0.1%
1784	72	0.1%
1537	72	0.1%
1578	72	0.1%
1812	71	0.1%
1590	71	0.1%
Other values (45628)	138045	99.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
959	1	< 0.1%
966	1	< 0.1%
980	1	< 0.1%
999	1	< 0.1%
1001	1	< 0.1%
1002	1	< 0.1%
1003	2	< 0.1%
1004	1	< 0.1%
1005	1	< 0.1%
1006	1	< 0.1%

Value	Count	Frequency (%)
5402.72	1	< 0.1%
5399	1	< 0.1%
5390	1	< 0.1%
5348.84	1	< 0.1%
5336.53	1	< 0.1%
5297.23	1	< 0.1%
5295.02	1	< 0.1%
5290.24	1	< 0.1%
5289.39	1	< 0.1%
5286	1	< 0.1%

Date
Real number (ℝ_≥0)

ZEROS

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.99950285

Minimum	0
Maximum	6
Zeros	19847
Zeros (%)	14.3%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	3
Q3	5
95-th percentile	6
Maximum	6
Range	6
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.000214279
Coefficient of variation (CV)	0.6668486011
Kurtosis	-1.250177853
Mean	2.99950285
Median Absolute Deviation (MAD)	2
Skewness	0.0001865299127
Sum	416304
Variance	4.000857163
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
0	19847	14.3%
1	19824	14.3%
2	19824	14.3%
3	19824	14.3%
4	19824	14.3%
5	19824	14.3%
6	19824	14.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	19847	14.3%
1	19824	14.3%
2	19824	14.3%
3	19824	14.3%
4	19824	14.3%
5	19824	14.3%
6	19824	14.3%

Value	Count	Frequency (%)
6	19824	14.3%
5	19824	14.3%
4	19824	14.3%
3	19824	14.3%
2	19824	14.3%
1	19824	14.3%
0	19847	14.3%

Hour
Real number (ℝ_≥0)

ZEROS

Distinct	24
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.50008286

Minimum	0
Maximum	23
Zeros	5782
Zeros (%)	4.2%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	6
median	12
Q3	17.5
95-th percentile	22
Maximum	23
Range	23
Interquartile range (IQR)	11.5

Descriptive statistics

Standard deviation	6.922167599
Coefficient of variation (CV)	0.6019232804
Kurtosis	-1.204170464
Mean	11.50008286
Median Absolute Deviation (MAD)	6
Skewness	-2.872424259 × 10^-6
Sum	1596108
Variance	47.91640427
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
1	5783	4.2%
2	5783	4.2%
23	5783	4.2%
22	5783	4.2%
21	5783	4.2%
20	5783	4.2%
19	5783	4.2%
18	5783	4.2%
17	5783	4.2%
16	5783	4.2%
Other values (14)	80961	58.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	5782	4.2%
1	5783	4.2%
2	5783	4.2%
3	5783	4.2%
4	5783	4.2%
5	5783	4.2%
6	5783	4.2%
7	5783	4.2%
8	5783	4.2%
9	5783	4.2%

Value	Count	Frequency (%)
23	5783	4.2%
22	5783	4.2%
21	5783	4.2%
20	5783	4.2%
19	5783	4.2%
18	5783	4.2%
17	5783	4.2%
16	5783	4.2%
15	5783	4.2%
14	5783	4.2%

Month
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.470383526

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	4
median	6
Q3	9
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	3.428032772
Coefficient of variation (CV)	0.5298036443
Kurtosis	-1.196339534
Mean	6.470383526
Median Absolute Deviation (MAD)	3
Skewness	0.003035689015
Sum	898031
Variance	11.75140869
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
3	11904	8.6%
5	11904	8.6%
7	11904	8.6%
8	11904	8.6%
10	11904	8.6%
1	11903	8.6%
4	11520	8.3%
6	11520	8.3%
9	11520	8.3%
12	11160	8.0%
Other values (2)	21648	15.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	11903	8.6%
2	10848	7.8%
3	11904	8.6%
4	11520	8.3%
5	11904	8.6%
6	11520	8.3%
7	11904	8.6%
8	11904	8.6%
9	11520	8.3%
10	11904	8.6%

Value	Count	Frequency (%)
12	11160	8.0%
11	10800	7.8%
10	11904	8.6%
9	11520	8.3%
8	11904	8.6%
7	11904	8.6%
6	11520	8.3%
5	11904	8.6%
4	11520	8.3%
3	11904	8.6%

TMAX-CAB
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	2134
Distinct (%)	1.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	32.99878551

Minimum	9.09
Maximum	49.61
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	9.09
5-th percentile	19.8
Q1	26.96
median	33.73
Q3	39.5
95-th percentile	44.06
Maximum	49.61
Range	40.52
Interquartile range (IQR)	12.54

Descriptive statistics

Standard deviation	7.801089285
Coefficient of variation (CV)	0.2364053454
Kurtosis	-0.8615582407
Mean	32.99878551
Median Absolute Deviation (MAD)	6.27
Skewness	-0.2962016899
Sum	4579934.44
Variance	60.85699404
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
40	1392	1.0%
38	1248	0.9%
41	1200	0.9%
26	1128	0.8%
39	1128	0.8%
36	1104	0.8%
23	1080	0.8%
31	1056	0.8%
25	1056	0.8%
37	1008	0.7%
Other values (2124)	127391	91.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
9.09	24	< 0.1%
11	24	< 0.1%
12	72	0.1%
12.09	24	< 0.1%
12.23	24	< 0.1%
12.3	24	< 0.1%
12.5	24	< 0.1%
12.81	24	< 0.1%
13	72	0.1%
13.1	24	< 0.1%

Value	Count	Frequency (%)
49.61	24	< 0.1%
49.53	24	< 0.1%
48.4	24	< 0.1%
48.1	24	< 0.1%
48	24	< 0.1%
47.87	24	< 0.1%
47.71	24	< 0.1%
47.69	24	< 0.1%
47.6	24	< 0.1%
47.53	24	< 0.1%

TMAX-HMO
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1328
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	33.55376026

Minimum	8
Maximum	49.1
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	8
5-th percentile	21.77
Q1	28.71
median	34.5
Q3	39
95-th percentile	43
Maximum	49.1
Range	41.1
Interquartile range (IQR)	10.29

Descriptive statistics

Standard deviation	6.634450905
Coefficient of variation (CV)	0.1977260031
Kurtosis	-0.6405264241
Mean	33.55376026
Median Absolute Deviation (MAD)	5
Skewness	-0.3834708529
Sum	4656959.94
Variance	44.01593881
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
37	3888	2.8%
39	3408	2.5%
38	3336	2.4%
35	3336	2.4%
40	3192	2.3%
41	3144	2.3%
36	2760	2.0%
42	2760	2.0%
34	2664	1.9%
30	2568	1.9%
Other values (1318)	107735	77.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
8	24	< 0.1%
14.58	24	< 0.1%
14.8	24	< 0.1%
15.5	48	< 0.1%
15.7	24	< 0.1%
15.71	24	< 0.1%
16	96	0.1%
16.01	24	< 0.1%
16.4	48	< 0.1%
16.5	144	0.1%

Value	Count	Frequency (%)
49.1	24	< 0.1%
48.86	24	< 0.1%
48	24	< 0.1%
47.58	24	< 0.1%
47.5	72	0.1%
47	96	0.1%
46.86	24	< 0.1%
46.5	120	0.1%
46.23	24	< 0.1%
46.2	24	< 0.1%

TMAX-OBR
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1243
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	34.53774279

Minimum	12
Maximum	47
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	12
5-th percentile	24
Q1	30
median	35.41
Q3	39.28
95-th percentile	43
Maximum	47
Range	35
Interquartile range (IQR)	9.28

Descriptive statistics

Standard deviation	5.927637647
Coefficient of variation (CV)	0.1716278242
Kurtosis	-0.649182679
Mean	34.53774279
Median Absolute Deviation (MAD)	4.59
Skewness	-0.4153157434
Sum	4793527.86
Variance	35.13688808
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
40	5856	4.2%
38	5568	4.0%
39	5424	3.9%
41	4992	3.6%
37	4704	3.4%
36	4320	3.1%
42	3792	2.7%
29	3744	2.7%
34	3648	2.6%
33	3600	2.6%
Other values (1233)	93143	67.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12	24	< 0.1%
15	24	< 0.1%
16	48	< 0.1%
17	96	0.1%
17.7	24	< 0.1%
18	96	0.1%
18.5	24	< 0.1%
18.83	24	< 0.1%
19	168	0.1%
19.2	24	< 0.1%

Value	Count	Frequency (%)
47	48	< 0.1%
46.5	24	< 0.1%
46.15	24	< 0.1%
46	168	0.1%
45.97	24	< 0.1%
45.85	24	< 0.1%
45.7	24	< 0.1%
45.68	24	< 0.1%
45.5	48	< 0.1%
45.45	24	< 0.1%

TMIN-CAB
Real number (ℝ)

HIGH CORRELATION

Distinct	2169
Distinct (%)	1.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	16.49558574

Minimum	-6.8
Maximum	32.9
Zeros	192
Zeros (%)	0.1%
Negative	720
Negative (%)	0.5%
Memory size	1.1 MiB

Quantile statistics

Minimum	-6.8
5-th percentile	4
Q1	10.1
median	16
Q3	23.57
95-th percentile	28.78
Maximum	32.9
Range	39.7
Interquartile range (IQR)	13.47

Descriptive statistics

Standard deviation	7.921575778
Coefficient of variation (CV)	0.4802239766
Kurtosis	-1.016973919
Mean	16.49558574
Median Absolute Deviation (MAD)	6.64
Skewness	-0.0117286117
Sum	2289438.84
Variance	62.75136281
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
22	1440	1.0%
12	1440	1.0%
24	1368	1.0%
10	1248	0.9%
8	1224	0.9%
14	1200	0.9%
9	1176	0.8%
15	1151	0.8%
23	1104	0.8%
26	1080	0.8%
Other values (2159)	126360	91.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-6.8	24	< 0.1%
-5.8	24	< 0.1%
-5.4	24	< 0.1%
-5	24	< 0.1%
-3.2	24	< 0.1%
-3	48	< 0.1%
-2.92	24	< 0.1%
-2.2	24	< 0.1%
-2.13	24	< 0.1%
-2	48	< 0.1%

Value	Count	Frequency (%)
32.9	24	< 0.1%
32.86	24	< 0.1%
32.5	24	< 0.1%
32.48	24	< 0.1%
32.36	24	< 0.1%
32.21	24	< 0.1%
32.06	24	< 0.1%
32.02	24	< 0.1%
32.01	24	< 0.1%
31.78	24	< 0.1%

TMIN-HMO
Real number (ℝ)

HIGH CORRELATION

Distinct	1338
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18.50379463

Minimum	-3
Maximum	34
Zeros	24
Zeros (%)	< 0.1%
Negative	24
Negative (%)	< 0.1%
Memory size	1.1 MiB

Quantile statistics

Minimum	-3
5-th percentile	7.09
Q1	13
median	18
Q3	25
95-th percentile	29
Maximum	34
Range	37
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	7.05737714
Coefficient of variation (CV)	0.3814016143
Kurtosis	-1.049131135
Mean	18.50379463
Median Absolute Deviation (MAD)	6
Skewness	-0.1101890143
Sum	2568160.16
Variance	49.8065721
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
27	4344	3.1%
26	3624	2.6%
25	3600	2.6%
11	3240	2.3%
16	3239	2.3%
28	3120	2.2%
13	3000	2.2%
14	2952	2.1%
22	2880	2.1%
12	2784	2.0%
Other values (1328)	106008	76.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-3	24	< 0.1%
0	24	< 0.1%
0.37	24	< 0.1%
0.46	24	< 0.1%
0.62	24	< 0.1%
0.66	24	< 0.1%
0.68	24	< 0.1%
0.7	24	< 0.1%
1.06	24	< 0.1%
1.23	24	< 0.1%

Value	Count	Frequency (%)
34	24	< 0.1%
33.4	24	< 0.1%
33.3	24	< 0.1%
32	168	0.1%
31.8	24	< 0.1%
31.73	24	< 0.1%
31.5	48	< 0.1%
31.39	24	< 0.1%
31.07	24	< 0.1%
31	720	0.5%

TMIN-OBR
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1304
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18.66678272

Minimum	2
Maximum	42.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	2
5-th percentile	8.22
Q1	13
median	18
Q3	25
95-th percentile	29
Maximum	42.5
Range	40.5
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	6.737229591
Coefficient of variation (CV)	0.36092077
Kurtosis	-1.139080852
Mean	18.66678272
Median Absolute Deviation (MAD)	6
Skewness	0.02303209835
Sum	2590781.44
Variance	45.39026256
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
26	5328	3.8%
25	4776	3.4%
14	4559	3.3%
27	4464	3.2%
24	4440	3.2%
10	4128	3.0%
13	3984	2.9%
16	3936	2.8%
15	3864	2.8%
11	3792	2.7%
Other values (1294)	95520	68.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	48	< 0.1%
2.6	24	< 0.1%
3	24	< 0.1%
3.3	24	< 0.1%
3.88	24	< 0.1%
4	48	< 0.1%
4.04	24	< 0.1%
4.1	24	< 0.1%
4.34	24	< 0.1%
4.48	24	< 0.1%

Value	Count	Frequency (%)
42.5	24	< 0.1%
33	24	< 0.1%
32	144	0.1%
31.96	24	< 0.1%
31.92	24	< 0.1%
31.67	24	< 0.1%
31.62	24	< 0.1%
31.56	24	< 0.1%
31.51	24	< 0.1%
31.41	24	< 0.1%

PREC_HMO (mm)
Real number (ℝ_≥0)

ZEROS

Distinct	252
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.398324099

Minimum	0
Maximum	117
Zeros	120839
Zeros (%)	87.1%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	7.2
Maximum	117
Range	117
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	6.939963432
Coefficient of variation (CV)	4.963057876
Kurtosis	76.87536046
Mean	1.398324099
Median Absolute Deviation (MAD)	0
Skewness	7.721436168
Sum	194074.8
Variance	48.16309244
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	120839	87.1%
0.01	3312	2.4%
1	480	0.3%
0.3	384	0.3%
1.2	360	0.3%
0.5	336	0.2%
0.1	312	0.2%
2	288	0.2%
0.2	288	0.2%
3	264	0.2%
Other values (242)	11928	8.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	120839	87.1%
0.01	3312	2.4%
0.04	24	< 0.1%
0.1	312	0.2%
0.2	288	0.2%
0.3	384	0.3%
0.4	192	0.1%
0.5	336	0.2%
0.6	96	0.1%
0.7	144	0.1%

Value	Count	Frequency (%)
117	24	< 0.1%
115	24	< 0.1%
103.9	24	< 0.1%
92.1	24	< 0.1%
83.5	24	< 0.1%
80.5	24	< 0.1%
80	24	< 0.1%
72.5	24	< 0.1%
72	24	< 0.1%
71.8	24	< 0.1%

PREC_OBR (mm)
Real number (ℝ_≥0)

ZEROS

Distinct	184
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.166726373

Minimum	0
Maximum	166.8
Zeros	122255
Zeros (%)	88.1%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	4.5
Maximum	166.8
Range	166.8
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	6.680982958
Coefficient of variation (CV)	5.726263771
Kurtosis	141.1251942
Mean	1.166726373
Median Absolute Deviation (MAD)	0
Skewness	10.03783287
Sum	161931.12
Variance	44.63553329
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	122255	88.1%
0.01	2856	2.1%
1	1440	1.0%
0.5	936	0.7%
2	720	0.5%
1.5	552	0.4%
3	480	0.3%
2.5	384	0.3%
5	336	0.2%
9	264	0.2%
Other values (174)	8568	6.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	122255	88.1%
0.01	2856	2.1%
0.05	24	< 0.1%
0.1	144	0.1%
0.2	216	0.2%
0.3	240	0.2%
0.4	24	< 0.1%
0.5	936	0.7%
0.6	96	0.1%
0.7	24	< 0.1%

Value	Count	Frequency (%)
166.8	24	< 0.1%
104	24	< 0.1%
102	24	< 0.1%
101	24	< 0.1%
91.7	24	< 0.1%
91	24	< 0.1%
85	24	< 0.1%
81	24	< 0.1%
80.6	24	< 0.1%
74	24	< 0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	FECHA	Demanda	Hour	Month	TMAX-CAB	TMAX-HMO	TMAX-OBR	TMIN-CAB	TMIN-HMO	TMIN-OBR
0	2007-01-01	1297.0	1	1	21.0	21.5	25.0	2.0	9.0	7.5
1	2007-01-01	1255.0	2	1	21.0	21.5	25.0	2.0	9.0	7.5
2	2007-01-01	1222.0	3	1	21.0	21.5	25.0	2.0	9.0	7.5
3	2007-01-01	1168.0	4	1	21.0	21.5	25.0	2.0	9.0	7.5
4	2007-01-01	1128.0	5	1	21.0	21.5	25.0	2.0	9.0	7.5
5	2007-01-01	1100.0	6	1	21.0	21.5	25.0	2.0	9.0	7.5
6	2007-01-01	1083.0	7	1	21.0	21.5	25.0	2.0	9.0	7.5
7	2007-01-01	1076.0	8	1	21.0	21.5	25.0	2.0	9.0	7.5
8	2007-01-01	1022.0	9	1	21.0	21.5	25.0	2.0	9.0	7.5
9	2007-01-01	1029.0	10	1	21.0	21.5	25.0	2.0	9.0	7.5

Last rows

	FECHA	Demanda	Hour	Month	TMAX-CAB	TMAX-HMO	TMAX-OBR	TMIN-CAB	TMIN-HMO	TMIN-OBR
138781	2022-10-31	2834.87	14	10	29.0	31.5	31.5	15.0	16.0	14.0
138782	2022-10-31	2914.07	15	10	29.0	31.5	31.5	15.0	16.0	14.0
138783	2022-10-31	2990.75	16	10	29.0	31.5	31.5	15.0	16.0	14.0
138784	2022-10-31	3038.08	17	10	29.0	31.5	31.5	15.0	16.0	14.0
138785	2022-10-31	3014.08	18	10	29.0	31.5	31.5	15.0	16.0	14.0
138786	2022-10-31	2934.74	19	10	29.0	31.5	31.5	15.0	16.0	14.0
138787	2022-10-31	2926.85	20	10	29.0	31.5	31.5	15.0	16.0	14.0
138788	2022-10-31	2894.38	21	10	29.0	31.5	31.5	15.0	16.0	14.0
138789	2022-10-31	2877.56	22	10	29.0	31.5	31.5	15.0	16.0	14.0
138790	2022-10-31	2843.08	23	10	29.0	31.5	31.5	15.0	16.0	14.0

Overview

Variables

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows